Tabela DescriptiveData

Definicja tabeli DescriptiveData

Name

DescriptiveData

Code

DescriptiveData

Comment

 


Lista kolumn tabeli DescriptiveData

Name

Code

DescriptiveDataID

DescriptiveDataID

DescriptiveDataTypeID

DescriptiveDataTypeID

PersonID

PersonID

EventID

EventID

DescriptiveDataStatusID

DescriptiveDataStatusID

SysFileTypeID

SysFileTypeID

Sys_SysFileTypeID

Sys_SysFileTypeID

FormInstanceID

FormInstanceID

ChangeNo

ChangeNo

DateValue

DateValue

Text

Text

FileReference

FileReference

StartDT

StartDT

StopDT

StopDT

Name

Name

InsertingPerson

InsertingPerson

InsertDate

InsertDate

CancelReason

CancelReason

IsAuthorized

IsAuthorized


Kolumna DescriptiveDataID tabeli DescriptiveData

Definicja kolumny DescriptiveDataID tabeli DescriptiveData

Name

DescriptiveDataID

Code

DescriptiveDataID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna DescriptiveDataTypeID tabeli DescriptiveData

Definicja kolumny DescriptiveDataTypeID tabeli DescriptiveData

Name

DescriptiveDataTypeID

Code

DescriptiveDataTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PersonID tabeli DescriptiveData

Definicja kolumny PersonID tabeli DescriptiveData

Name

PersonID

Code

PersonID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna EventID tabeli DescriptiveData

Definicja kolumny EventID tabeli DescriptiveData

Name

EventID

Code

EventID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DescriptiveDataStatusID tabeli DescriptiveData

Definicja kolumny DescriptiveDataStatusID tabeli DescriptiveData

Name

DescriptiveDataStatusID

Code

DescriptiveDataStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna SysFileTypeID tabeli DescriptiveData

Definicja kolumny SysFileTypeID tabeli DescriptiveData

Name

SysFileTypeID

Code

SysFileTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Sys_SysFileTypeID tabeli DescriptiveData

Definicja kolumny Sys_SysFileTypeID tabeli DescriptiveData

Name

Sys_SysFileTypeID

Code

Sys_SysFileTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna FormInstanceID tabeli DescriptiveData

Definicja kolumny FormInstanceID tabeli DescriptiveData

Name

FormInstanceID

Code

FormInstanceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ChangeNo tabeli DescriptiveData

Definicja kolumny ChangeNo tabeli DescriptiveData

Name

ChangeNo

Code

ChangeNo

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DateValue tabeli DescriptiveData

Definicja kolumny DateValue tabeli DescriptiveData

Name

DateValue

Code

DateValue

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Text tabeli DescriptiveData

Definicja kolumny Text tabeli DescriptiveData

Name

Text

Code

Text

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna FileReference tabeli DescriptiveData

Definicja kolumny FileReference tabeli DescriptiveData

Name

FileReference

Code

FileReference

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna StartDT tabeli DescriptiveData

Definicja kolumny StartDT tabeli DescriptiveData

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli DescriptiveData

Definicja kolumny StopDT tabeli DescriptiveData

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Name tabeli DescriptiveData

Definicja kolumny Name tabeli DescriptiveData

Name

Name

Code

Name

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Kolumna Name razem z FileReference opisuje plik zapisany w starym archiwum dokumentacji medycznej, które jest uruchomione np. w IGP.


Kolumna InsertingPerson tabeli DescriptiveData

Definicja kolumny InsertingPerson tabeli DescriptiveData

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDate tabeli DescriptiveData

Definicja kolumny InsertDate tabeli DescriptiveData

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna CancelReason tabeli DescriptiveData

Definicja kolumny CancelReason tabeli DescriptiveData

Name

CancelReason

Code

CancelReason

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Powód anulowania danej opisowej


Kolumna IsAuthorized tabeli DescriptiveData

Definicja kolumny IsAuthorized tabeli DescriptiveData

Name

IsAuthorized

Code

IsAuthorized

Data Type

NUMBER(3)

Mandatory

No

Comment

Czy jest zautoryzowana


Lista kluczy tabeli DescriptiveData

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli DescriptiveData

Definicja klucza Identifier_1 tabeli DescriptiveData

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment